<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Products" targetNamespace="http://tempuri.org/Products.xsd" xmlns:mstns="http://tempuri.org/Products.xsd" xmlns="http://tempuri.org/Products.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PoserFilesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PoserFilesConnectionString (MySettings)" PropertyReference="ApplicationSettings.PoserFiles.My.MySettings.GlobalReference.Default.PoserFilesConnectionString" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FilesTableAdapter" GeneratorDataComponentClassName="FilesTableAdapter" Name="Files" UserDataComponentName="FilesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM Files
WHERE     (file_id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="file_id" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="file_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     filename, code, provider, disc, product_link, file_id, LocalImage, ImageName, Comments
FROM         Files</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    Files
SET              provider = ?, disc = ?
WHERE     (file_id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="disc" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="disc" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="disc" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="file_id" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_file_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="filename" DataSetColumn="filename" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="provider" DataSetColumn="provider" />
              <Mapping SourceColumn="disc" DataSetColumn="disc" />
              <Mapping SourceColumn="product_link" DataSetColumn="product_link" />
              <Mapping SourceColumn="file_id" DataSetColumn="file_id" />
              <Mapping SourceColumn="LocalImage" DataSetColumn="LocalImage" />
              <Mapping SourceColumn="ImageName" DataSetColumn="ImageName" />
              <Mapping SourceColumn="Comments" DataSetColumn="Comments" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="FileCount" Modifier="Public" Name="FileCount" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="FileCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*) FROM Files</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="FileCountByCode" Modifier="Public" Name="FileCountByCode" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="FileCountByCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Files
WHERE     (code = ?) AND (provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="code" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="code" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByArtist" GeneratorSourceName="FillByArtist" GetMethodModifier="Public" GetMethodName="GetDataByArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByArtist" UserSourceName="FillByArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByArtistAndProvider" GeneratorSourceName="FillByArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByArtistAndProvider" UserSourceName="FillByArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDuplicates" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByDuplicates" GeneratorSourceName="FillByDuplicates" GetMethodModifier="Public" GetMethodName="GetDataByDuplicates" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByDuplicates" UserSourceName="FillByDuplicates">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM Files INNER JOIN (SELECT F.code, F.provider, Count(F.file_id) AS CountOffile_id
FROM Files AS F
GROUP BY F.code, F.provider
HAVING (((F.code)&lt;&gt;"") AND ((Count(F.file_id))&gt;1)) )  AS Files2 ON (Files.provider = Files2.provider) AND (Files.code = Files2.code)
ORDER BY Files.code, Files.provider</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigure" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigure" GeneratorSourceName="FillByFigure" GetMethodModifier="Public" GetMethodName="GetDataByFigure" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigure" UserSourceName="FillByFigure">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id)
WHERE     (FileForFigure.figure = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndArtist" GeneratorSourceName="FillByFigureAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndArtist" UserSourceName="FillByFigureAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndArtistAndProvider" GeneratorSourceName="FillByFigureAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndArtistAndProvider" UserSourceName="FillByFigureAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndLicense" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndLicense" GeneratorSourceName="FillByFigureAndLicense" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndLicense" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndLicense" UserSourceName="FillByFigureAndLicense">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id)
WHERE     (FileForFigure.figure = ?) AND (Files.license = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndLicenseAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndLicenseAndArtist" GeneratorSourceName="FillByFigureAndLicenseAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndLicenseAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndLicenseAndArtist" UserSourceName="FillByFigureAndLicenseAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (Files.license = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndLicenseAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndLicenseAndArtistAndProvider" GeneratorSourceName="FillByFigureAndLicenseAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndLicenseAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndLicenseAndArtistAndProvider" UserSourceName="FillByFigureAndLicenseAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (Files.license = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndLicenseAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndLicenseAndProvider" GeneratorSourceName="FillByFigureAndLicenseAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndLicenseAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndLicenseAndProvider" UserSourceName="FillByFigureAndLicenseAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id)
WHERE     (FileForFigure.figure = ?) AND (Files.license = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductType" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductType" GeneratorSourceName="FillByFigureAndProductType" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductType" UserSourceName="FillByFigureAndProductType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndArtist" GeneratorSourceName="FillByFigureAndProductTypeAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndArtist" UserSourceName="FillByFigureAndProductTypeAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndArtistAndVendor" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndArtistAndVendor" GeneratorSourceName="FillByFigureAndProductTypeAndArtistAndVendor" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndArtistAndVendor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndArtistAndVendor" UserSourceName="FillByFigureAndProductTypeAndArtistAndVendor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndLicense" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndLicense" GeneratorSourceName="FillByFigureAndProductTypeAndLicense" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndLicense" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndLicense" UserSourceName="FillByFigureAndProductTypeAndLicense">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (Files.license = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndLicenseAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtist" GeneratorSourceName="FillByFigureAndProductTypeAndLicenseAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtist" UserSourceName="FillByFigureAndProductTypeAndLicenseAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (Files.license = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param4" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndLicenseAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtistAndProvider" GeneratorSourceName="FillByFigureAndProductTypeAndLicenseAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndArtistAndProvider" UserSourceName="FillByFigureAndProductTypeAndLicenseAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (Files.license = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param4" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param5" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndLicenseAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndProvider" GeneratorSourceName="FillByFigureAndProductTypeAndLicenseAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndLicenseAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndLicenseAndProvider" UserSourceName="FillByFigureAndProductTypeAndLicenseAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (Files.license = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProductTypeAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProductTypeAndProvider" GeneratorSourceName="FillByFigureAndProductTypeAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProductTypeAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProductTypeAndProvider" UserSourceName="FillByFigureAndProductTypeAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id) INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileForFigure.figure = ?) AND (FileProductType.product_type = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFigureAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByFigureAndProvider" GeneratorSourceName="FillByFigureAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByFigureAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByFigureAndProvider" UserSourceName="FillByFigureAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileForFigure ON Files.file_id = FileForFigure.file_id)
WHERE     (FileForFigure.figure = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="figure" DataSourceName="FileForFigure" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="figure" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="figure" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLicense" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByLicense" GeneratorSourceName="FillByLicense" GetMethodModifier="Public" GetMethodName="GetDataByLicense" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByLicense" UserSourceName="FillByLicense">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     filename, code, provider, disc, product_link, file_id, LocalImage, ImageName, Comments
FROM         Files
WHERE     (license = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLicenseAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByLicenseAndArtist" GeneratorSourceName="FillByLicenseAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByLicenseAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByLicenseAndArtist" UserSourceName="FillByLicenseAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (Files.license = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLicenseAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByLicenseAndArtistAndProvider" GeneratorSourceName="FillByLicenseAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByLicenseAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByLicenseAndArtistAndProvider" UserSourceName="FillByLicenseAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (Files.license = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLicenseAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByLicenseAndProvider" GeneratorSourceName="FillByLicenseAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByLicenseAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByLicenseAndProvider" UserSourceName="FillByLicenseAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     filename, code, provider, disc, product_link, file_id, LocalImage, ImageName, Comments
FROM         Files
WHERE     (license = ?) AND (provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductType" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductType" GeneratorSourceName="FillByProductType" GetMethodModifier="Public" GetMethodName="GetDataByProductType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductType" UserSourceName="FillByProductType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileProductType.product_type = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndArtist" GeneratorSourceName="FillByProductTypeAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndArtist" UserSourceName="FillByProductTypeAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileProductType.product_type = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndArtistAndProvider" GeneratorSourceName="FillByProductTypeAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndArtistAndProvider" UserSourceName="FillByProductTypeAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileProductType.product_type = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndLicense" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndLicense" GeneratorSourceName="FillByProductTypeAndLicense" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndLicense" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndLicense" UserSourceName="FillByProductTypeAndLicense">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileProductType.product_type = ?) AND (Files.license = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndLicenseAndArtist" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndLicenseAndArtist" GeneratorSourceName="FillByProductTypeAndLicenseAndArtist" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndLicenseAndArtist" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndLicenseAndArtist" UserSourceName="FillByProductTypeAndLicenseAndArtist">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileProductType.product_type = ?) AND (Files.license = ?) AND (FileArtist.artist = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndLicenseAndArtistAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndLicenseAndArtistAndProvider" GeneratorSourceName="FillByProductTypeAndLicenseAndArtistAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndLicenseAndArtistAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndLicenseAndArtistAndProvider" UserSourceName="FillByProductTypeAndLicenseAndArtistAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         ((Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id) INNER JOIN
                      FileArtist ON Files.file_id = FileArtist.file_id)
WHERE     (FileProductType.product_type = ?) AND (Files.license = ?) AND (FileArtist.artist = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param3" ColumnName="artist" DataSourceName="FileArtist" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="artist" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="artist" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndLicenseAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndLicenseAndProvider" GeneratorSourceName="FillByProductTypeAndLicenseAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndLicenseAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndLicenseAndProvider" UserSourceName="FillByProductTypeAndLicenseAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileProductType.product_type = ?) AND (Files.license = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="license" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductTypeAndProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProductTypeAndProvider" GeneratorSourceName="FillByProductTypeAndProvider" GetMethodModifier="Public" GetMethodName="GetDataByProductTypeAndProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProductTypeAndProvider" UserSourceName="FillByProductTypeAndProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Files.filename, Files.code, Files.provider, Files.disc, Files.product_link, Files.file_id, Files.LocalImage, Files.ImageName, Files.Comments
FROM         (Files INNER JOIN
                      FileProductType ON Files.file_id = FileProductType.file_id)
WHERE     (FileProductType.product_type = ?) AND (Files.provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="product_type" DataSourceName="FileProductType" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="product_type" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="product_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProvider" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByProvider" GeneratorSourceName="FillByProvider" GetMethodModifier="Public" GetMethodName="GetDataByProvider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByProvider" UserSourceName="FillByProvider">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     filename, code, provider, disc, product_link, file_id, LocalImage, ImageName, Comments
FROM         Files
WHERE     (provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Products" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Products" msprop:Generator_DataSetName="Products">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Files" msprop:Generator_UserTableName="Files" msprop:Generator_RowDeletedName="FilesRowDeleted" msprop:Generator_RowChangedName="FilesRowChanged" msprop:Generator_RowClassName="FilesRow" msprop:Generator_RowChangingName="FilesRowChanging" msprop:Generator_RowEvArgName="FilesRowChangeEvent" msprop:Generator_RowEvHandlerName="FilesRowChangeEventHandler" msprop:Generator_TableClassName="FilesDataTable" msprop:Generator_TableVarName="tableFiles" msprop:Generator_RowDeletingName="FilesRowDeleting" msprop:Generator_TablePropName="Files">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="filename" msprop:Generator_UserColumnName="filename" msprop:Generator_ColumnVarNameInTable="columnfilename" msprop:Generator_ColumnPropNameInRow="filename" msprop:Generator_ColumnPropNameInTable="filenameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="code" msprop:Generator_UserColumnName="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnPropNameInTable="codeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="provider" msprop:Generator_UserColumnName="provider" msprop:Generator_ColumnVarNameInTable="columnprovider" msprop:Generator_ColumnPropNameInRow="provider" msprop:Generator_ColumnPropNameInTable="providerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="75" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="disc" msprop:Generator_UserColumnName="disc" msprop:Generator_ColumnVarNameInTable="columndisc" msprop:Generator_ColumnPropNameInRow="disc" msprop:Generator_ColumnPropNameInTable="discColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="product_link" msprop:Generator_UserColumnName="product_link" msprop:Generator_ColumnVarNameInTable="columnproduct_link" msprop:Generator_ColumnPropNameInRow="product_link" msprop:Generator_ColumnPropNameInTable="product_linkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="file_id" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="file_id" msprop:Generator_ColumnPropNameInRow="file_id" msprop:Generator_ColumnVarNameInTable="columnfile_id" msprop:Generator_ColumnPropNameInTable="file_idColumn" type="xs:int" />
              <xs:element name="LocalImage" msprop:Generator_UserColumnName="LocalImage" msprop:Generator_ColumnVarNameInTable="columnLocalImage" msprop:Generator_ColumnPropNameInRow="LocalImage" msprop:Generator_ColumnPropNameInTable="LocalImageColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ImageName" msprop:Generator_UserColumnName="ImageName" msprop:Generator_ColumnVarNameInTable="columnImageName" msprop:Generator_ColumnPropNameInRow="ImageName" msprop:Generator_ColumnPropNameInTable="ImageNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comments" msprop:Generator_UserColumnName="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Files" />
      <xs:field xpath="mstns:file_id" />
    </xs:unique>
  </xs:element>
</xs:schema>